[dbo].[BAEImisTransGetAllByUserIdAndProductCode]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisTransGetAllByUserIdAndProductCode

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UserId	varchar(10)	10
@ProductCode	varchar(31)	31

SQL Script

create procedure [dbo].[BAEImisTransGetAllByUserIdAndProductCode] @UserId as
varchar(10),
    @ProductCode AS varchar(31)
AS
    SELECT * FROM Trans
    WHERE ST_ID = @UserId AND PRODUCT_CODE = @ProductCode;

GO

Uses

[dbo].[Trans]
dbo